﻿

alter PROCEDURE [PomSelectPropertyAttributes]
(
	@pPomplingAddressID VARCHAR(32)
)
AS
BEGIN
	SET NOCOUNT ON;	
	SELECT wpa.[PomplingAddressID],	wpa.LookupText, wpa.[PropertyAttributeLookupID] LookupID, wpa.[AttributeDescription], wpa.Displayposition
		FROM PomWebPropertiesAttributes wpa 
		WHERE wpa.[PomplingAddressID] = @pPomplingAddressID
	order by Displayposition ASC
END
